﻿/*
LICENCE___________________________________________________________________
    Copyright (C) 2012 Reverdy Sylvain

    This program is free software; you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation; either version 2 of the License, or
    (at your option) any later version.

    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License along
    with this program; if not, write to the Free Software Foundation, Inc.,
    51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
FIN LICENCE______________________________________________________________
*/
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;

namespace Merise_designer.Donnees
{
    class D_Type
    {
        private CL_CAD cad = new CL_CAD();
        public DataSet getAllTypes(string monJeu)
        {
            string req = @"SELECT ID_TYPE, NOM_TYPE FROM TYPES";
            return cad.GetRows(req, monJeu);
        }
        public Objets.CL_Type getType(int idType, string monJeu)
        {
            string req = @"SELECT ID_TYPE, NOM_TYPE FROM TYPES WHERE ID_TYPE="+idType+"";
            foreach (System.Data.DataRow theRow in cad.GetRows(req, monJeu).Tables[monJeu].Rows)
            {
                return new Objets.CL_Type(int.Parse(theRow["ID_TYPE"].ToString()),(String)theRow["NOM_TYPE"]);
            }
            return null;
        }
    }
}
